package com.wl.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.wl.entity.Delivery_07;

public interface Delivery_07Mapper {

	public int deleteByPrimaryKey(Integer id);

	public int insert(Delivery_07 record);

	/**
	 * 动态sql语句添加出库业务信息
	 * 
	 * @param record
	 * @return
	 */
	public int insertSelective(Delivery_07 record);

	public Delivery_07 selectByPrimaryKey(Integer id);

	/**
	 * 根据id动态修改
	 * @param record
	 * @return
	 */
	public int updateByPrimaryKeySelective(Delivery_07 record);

	public int updateByPrimaryKey(Delivery_07 record);
	
	/**
	 * 分页+按照处理人编号查询当前未处理业务
	 * @param start
	 * @param limit
	 * @param deliveryno
	 * @return
	 */
	public List<Delivery_07> selectDeliveryByDeliveryno(@Param("start") int start, @Param("pageSize") int limit,
			@Param("deliveryno") String deliveryno);
	
	/**
	 * 查询得到该处理人当前未处理业务数
	 * @param deliveryno
	 * @return
	 */
	public int selectDeliveryByDeliverynoCount(@Param("deliveryno") String deliveryno);

	/**
	 * 查询已审批的数量，页面显示用
	 * @return
	 */
	public int getCountByDelivery();
}